package com.reef.dao;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import com.reef.entity.Reader;
/**
 * 学生管理接口处
 * @author qiang
 *
 */
public interface StudentRepository extends JpaRepository<Reader, Integer>,JpaSpecificationExecutor<Reader>{
	/**
	 * 查询专业
	 */
	@Query(value = "select distinct profession from reader where profession !='未知'" ,nativeQuery = true )
	List<String> selProfession();
}
